package com.fierce.cloud.ota.dao;

import com.fierce.cloud.core.common.mapper.Mapper;
import com.fierce.cloud.ota.model.VersionInfo;
import org.apache.ibatis.annotations.Select;

/**
 * @author: Fierce
 * @Date: 2021/2/26 11:33
 */
@org.apache.ibatis.annotations.Mapper
public interface VersionInfoMapper extends Mapper<VersionInfo> {

    VersionInfo selectNewestVersionByAppId(Long appId);

    @Select("select  count(1) count from version_info WHERE DATE_FORMAT(upload_time,'%Y-%m-%d') = #{dtae}")
    Integer countVersionCountByDate(String date);

}
